create table hr_user
(
    user_uuid      varchar(64) not null
        constraint hr_user_pk
            primary key nonclustered,
    fk_sys_user_id bigint      not null,
    id_num         varchar,
    remark         nvarchar(64)
)
go

exec sp_addextendedproperty 'MS_Description', '用户信息表-附表', 'SCHEMA', 'dbo', 'TABLE', 'hr_user'
go

exec sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', 'dbo', 'TABLE', 'hr_user', 'COLUMN', 'user_uuid'
go

exec sp_addextendedproperty 'MS_Description', '系统用户ID-外键', 'SCHEMA', 'dbo', 'TABLE', 'hr_user', 'COLUMN',
     'fk_sys_user_id'
go

exec sp_addextendedproperty 'MS_Description', '身份证号', 'SCHEMA', 'dbo', 'TABLE', 'hr_user', 'COLUMN', 'id_num'
go

exec sp_addextendedproperty 'MS_Description', '备注', 'SCHEMA', 'dbo', 'TABLE', 'hr_user', 'COLUMN', 'remark'
go

INSERT INTO [ry-vue].dbo.hr_user (user_uuid, fk_sys_user_id, id_num, remark) VALUES (N'8861D30E-8953-4E5D-87EE-47A4BF08B8E2', 1, N'1', N'');
INSERT INTO [ry-vue].dbo.hr_user (user_uuid, fk_sys_user_id, id_num, remark) VALUES (N'650185A2-88CE-453C-91CF-3BC1DE9161C4', 1, N'1', N'');
INSERT INTO [ry-vue].dbo.hr_user (user_uuid, fk_sys_user_id, id_num, remark) VALUES (N'6BD42DE8-6923-4BBA-BEC6-60B314C1B961', 1, N'1', N'');